CREATE TABLE [dbo].[JY_Company]
(
[JY_Company_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_Company_Login] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Passwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Question] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Answer] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Vocation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Properly] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Address_Area] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Address_City] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Url] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Linkman] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Fax] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Regist_Time] [datetime] NULL,
[JY_Company_Status] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Licence_Code] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Visible] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Coop_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Company_Up_Status] [int] NULL,
[JY_Company_Location] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[JY_Company] ADD 
CONSTRAINT [PK_JY_Company] PRIMARY KEY CLUSTERED  ([JY_Company_ID]) ON [PRIMARY]
GO
